home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 April / CMCD0404.ISO / Software / Shareware / Programare / sharp / wwwSharp_setup.exe / {app} / Examples / Data access / MasterDetails / CustomersOrders.xsd < prev    next >
Encoding:
Extensible Markup Language  |  2003-12-15  |  3.1 KB  |  54 lines
  1. <?xml version="1.0" standalone="yes"?>
  2. <xs:schema id="CustomersOrders" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  3.   <xs:element name="CustomersOrders" msdata:IsDataSet="true" msdata:Locale="ru-RU">
  4.     <xs:complexType>
  5.       <xs:choice maxOccurs="unbounded">
  6.         <xs:element name="Customers">
  7.           <xs:complexType>
  8.             <xs:sequence>
  9.               <xs:element name="CustomerID" type="xs:string" minOccurs="0" />
  10.               <xs:element name="CompanyName" type="xs:string" minOccurs="0" />
  11.               <xs:element name="ContactName" type="xs:string" minOccurs="0" />
  12.               <xs:element name="ContactTitle" type="xs:string" minOccurs="0" />
  13.               <xs:element name="Address" type="xs:string" minOccurs="0" />
  14.               <xs:element name="City" type="xs:string" minOccurs="0" />
  15.               <xs:element name="Region" type="xs:string" minOccurs="0" />
  16.               <xs:element name="PostalCode" type="xs:string" minOccurs="0" />
  17.               <xs:element name="Country" type="xs:string" minOccurs="0" />
  18.               <xs:element name="Phone" type="xs:string" minOccurs="0" />
  19.               <xs:element name="Fax" type="xs:string" minOccurs="0" />
  20.               <xs:element name="Orders" minOccurs="0" maxOccurs="unbounded">
  21.                 <xs:complexType>
  22.                   <xs:sequence>
  23.                     <xs:element name="OrderID" type="xs:int" minOccurs="0" />
  24.                     <xs:element name="CustomerID" type="xs:string" minOccurs="0" />
  25.                     <xs:element name="EmployeeID" type="xs:int" minOccurs="0" />
  26.                     <xs:element name="OrderDate" type="xs:dateTime" minOccurs="0" />
  27.                     <xs:element name="RequiredDate" type="xs:dateTime" minOccurs="0" />
  28.                     <xs:element name="ShippedDate" type="xs:dateTime" minOccurs="0" />
  29.                     <xs:element name="ShipVia" type="xs:int" minOccurs="0" />
  30.                     <xs:element name="Freight" type="xs:decimal" minOccurs="0" />
  31.                     <xs:element name="ShipName" type="xs:string" minOccurs="0" />
  32.                     <xs:element name="ShipAddress" type="xs:string" minOccurs="0" />
  33.                     <xs:element name="ShipCity" type="xs:string" minOccurs="0" />
  34.                     <xs:element name="ShipRegion" type="xs:string" minOccurs="0" />
  35.                     <xs:element name="ShipPostalCode" type="xs:string" minOccurs="0" />
  36.                     <xs:element name="ShipCountry" type="xs:string" minOccurs="0" />
  37.                   </xs:sequence>
  38.                 </xs:complexType>
  39.               </xs:element>
  40.             </xs:sequence>
  41.           </xs:complexType>
  42.         </xs:element>
  43.       </xs:choice>
  44.     </xs:complexType>
  45.     <xs:unique name="Constraint1">
  46.       <xs:selector xpath=".//Customers" />
  47.       <xs:field xpath="CustomerID" />
  48.     </xs:unique>
  49.     <xs:keyref name="Customers2Orders" refer="Constraint1" msdata:IsNested="true">
  50.       <xs:selector xpath=".//Orders" />
  51.       <xs:field xpath="CustomerID" />
  52.     </xs:keyref>
  53.   </xs:element>
  54. </xs:schema>